﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="ExceptionDS" targetNamespace="http://tempuri.org/ExceptionDS.xsd" xmlns:mstns="http://tempuri.org/ExceptionDS.xsd" xmlns="http://tempuri.org/ExceptionDS.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="UcConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Public" Name="UcConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.UCENTRIK.Properties.Settings.GlobalReference.Default.UcConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ExceptionDSTableAdapter" GeneratorDataComponentClassName="ExceptionDSTableAdapter" Name="ExceptionDS" UserDataComponentName="ExceptionDSTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="UcConnectionString (Settings)" DbObjectName="UC_WEB.dbo.usp_exception_select" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="GetData">
                <DeleteCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.usp_exception_delete</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ex_id" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="ex_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.usp_exception_insert</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@parent_ex_id" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="parent_ex_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@ex_message" Precision="0" ProviderType="NVarChar" Scale="0" Size="500" SourceColumn="ex_message" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@ex_stacktrace" Precision="0" ProviderType="NVarChar" Scale="0" Size="1000" SourceColumn="ex_stacktrace" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@username" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="username" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@page_url" Precision="0" ProviderType="NVarChar" Scale="0" Size="250" SourceColumn="page_url" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.usp_exception_select</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ex_id" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ex_id" DataSetColumn="ex_id" />
              <Mapping SourceColumn="ex_message" DataSetColumn="ex_message" />
              <Mapping SourceColumn="ex_stacktrace" DataSetColumn="ex_stacktrace" />
              <Mapping SourceColumn="username" DataSetColumn="username" />
              <Mapping SourceColumn="page_url" DataSetColumn="page_url" />
              <Mapping SourceColumn="date_created" DataSetColumn="date_created" />
              <Mapping SourceColumn="date_deleted" DataSetColumn="date_deleted" />
              <Mapping SourceColumn="is_deleted" DataSetColumn="is_deleted" />
              <Mapping SourceColumn="parent_ex_id" DataSetColumn="parent_ex_id" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="UcConnectionString (Settings)" DbObjectName="UC_WEB.dbo.usp_exception_get_all" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetAllExceptions" GetMethodModifier="Public" GetMethodName="GetAllExceptions" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetAllExceptions" UserSourceName="GetAllExceptions">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.usp_exception_get_all</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="UcConnectionString (Settings)" DbObjectName="UC_WEB.dbo.usp_exception_insert" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="InsertException" Modifier="Public" Name="InsertException" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="InsertException">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.usp_exception_insert</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@parent_ex_id" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@ex_message" Precision="0" ProviderType="NVarChar" Scale="0" Size="500" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@ex_stacktrace" Precision="0" ProviderType="NVarChar" Scale="0" Size="1000" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@application" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@username" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@page_url" Precision="0" ProviderType="NVarChar" Scale="0" Size="250" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="ExceptionDS" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="ExceptionDS" msprop:Generator_DataSetName="ExceptionDS" msprop:EnableTableAdapterManager="true">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="ExceptionDS" msprop:Generator_UserTableName="ExceptionDS" msprop:Generator_RowDeletedName="ExceptionDSRowDeleted" msprop:Generator_RowChangedName="ExceptionDSRowChanged" msprop:Generator_RowClassName="ExceptionDSRow" msprop:Generator_RowChangingName="ExceptionDSRowChanging" msprop:Generator_RowEvArgName="ExceptionDSRowChangeEvent" msprop:Generator_RowEvHandlerName="ExceptionDSRowChangeEventHandler" msprop:Generator_TableClassName="ExceptionDSDataTable" msprop:Generator_TableVarName="tableExceptionDS" msprop:Generator_RowDeletingName="ExceptionDSRowDeleting" msprop:Generator_TablePropName="_ExceptionDS">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ex_id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="ex_id" msprop:Generator_ColumnVarNameInTable="columnex_id" msprop:Generator_ColumnPropNameInRow="ex_id" msprop:Generator_ColumnPropNameInTable="ex_idColumn" type="xs:int" />
              <xs:element name="ex_message" msprop:Generator_UserColumnName="ex_message" msprop:Generator_ColumnVarNameInTable="columnex_message" msprop:Generator_ColumnPropNameInRow="ex_message" msprop:Generator_ColumnPropNameInTable="ex_messageColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ex_stacktrace" msprop:Generator_UserColumnName="ex_stacktrace" msprop:Generator_ColumnVarNameInTable="columnex_stacktrace" msprop:Generator_ColumnPropNameInRow="ex_stacktrace" msprop:Generator_ColumnPropNameInTable="ex_stacktraceColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="username" msprop:Generator_UserColumnName="username" msprop:Generator_ColumnVarNameInTable="columnusername" msprop:Generator_ColumnPropNameInRow="username" msprop:Generator_ColumnPropNameInTable="usernameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="page_url" msprop:Generator_UserColumnName="page_url" msprop:Generator_ColumnVarNameInTable="columnpage_url" msprop:Generator_ColumnPropNameInRow="page_url" msprop:Generator_ColumnPropNameInTable="page_urlColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="date_created" msprop:Generator_UserColumnName="date_created" msprop:Generator_ColumnVarNameInTable="columndate_created" msprop:Generator_ColumnPropNameInRow="date_created" msprop:Generator_ColumnPropNameInTable="date_createdColumn" type="xs:dateTime" />
              <xs:element name="date_deleted" msprop:Generator_UserColumnName="date_deleted" msprop:Generator_ColumnVarNameInTable="columndate_deleted" msprop:Generator_ColumnPropNameInRow="date_deleted" msprop:Generator_ColumnPropNameInTable="date_deletedColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="is_deleted" msprop:Generator_UserColumnName="is_deleted" msprop:Generator_ColumnVarNameInTable="columnis_deleted" msprop:Generator_ColumnPropNameInRow="is_deleted" msprop:Generator_ColumnPropNameInTable="is_deletedColumn" type="xs:boolean" />
              <xs:element name="parent_ex_id" msprop:Generator_UserColumnName="parent_ex_id" msprop:Generator_ColumnVarNameInTable="columnparent_ex_id" msprop:Generator_ColumnPropNameInRow="parent_ex_id" msprop:Generator_ColumnPropNameInTable="parent_ex_idColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ExceptionDS" />
      <xs:field xpath="mstns:ex_id" />
    </xs:unique>
  </xs:element>
</xs:schema>